Pandas Profiling Report

Dataset statistics

Number of variables	27
Number of observations	3000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	632.9 KiB
Average record size in memory	216.0 B

Variable types

Numeric	8
Categorical	15
Boolean	1
DateTime	3

Alerts

`PatientID` has unique values	Unique
`NumHealthcareVisits` has 164 (5.5%) zeros	Zeros

Reproduction

Analysis started	2024-07-16 01:15:51.019612
Analysis finished	2024-07-16 01:16:17.617631
Duration	26.6 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

PatientID
Real number (ℝ)

UNIQUE

Distinct	3000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.9031143 × 10¹²

Minimum	1.2776501 × 10⁸
Maximum	9.9959456 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.6 KiB

Quantile statistics

Minimum	1.2776501 × 10⁸
5-th percentile	5.2104461 × 10¹¹
Q1	2.4519326 × 10¹²
median	4.829809 × 10¹²
Q3	7.3470709 × 10¹²
95-th percentile	9.4439364 × 10¹²
Maximum	9.9959456 × 10¹²
Range	9.9958178 × 10¹²
Interquartile range (IQR)	4.8951383 × 10¹²

Descriptive statistics

Standard deviation	2.859756 × 10¹²
Coefficient of variation (CV)	0.58325297
Kurtosis	-1.1846337
Mean	4.9031143 × 10¹²
Median Absolute Deviation (MAD)	2.4522073 × 10¹²
Skewness	0.048171061
Sum	1.4709343 × 10¹⁶
Variance	8.1782043 × 10²⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.479647884 × 10¹²	1	< 0.1%
6.554672046 × 10¹²	1	< 0.1%
5.967086123 × 10¹¹	1	< 0.1%
5.79265433 × 10¹²	1	< 0.1%
1.033866484 × 10¹²	1	< 0.1%
6.50918191 × 10¹²	1	< 0.1%
2.518596627 × 10¹²	1	< 0.1%
3.952356797 × 10¹²	1	< 0.1%
6.67795844 × 10¹²	1	< 0.1%
9.530799161 × 10¹²	1	< 0.1%
Other values (2990)	2990	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
127765011	1	< 0.1%
2701347156	1	< 0.1%
3485322605	1	< 0.1%
2.166624908 × 10¹⁰	1	< 0.1%
2.57588564 × 10¹⁰	1	< 0.1%
2.612047544 × 10¹⁰	1	< 0.1%
2.838905707 × 10¹⁰	1	< 0.1%
2.936088486 × 10¹⁰	1	< 0.1%
4.52462392 × 10¹⁰	1	< 0.1%
4.854021345 × 10¹⁰	1	< 0.1%

Value	Count	Frequency (%)
9.995945605 × 10¹²	1	< 0.1%
9.984733852 × 10¹²	1	< 0.1%
9.983869172 × 10¹²	1	< 0.1%
9.983855358 × 10¹²	1	< 0.1%
9.982106498 × 10¹²	1	< 0.1%
9.981010584 × 10¹²	1	< 0.1%
9.979627801 × 10¹²	1	< 0.1%
9.977829731 × 10¹²	1	< 0.1%
9.973363977 × 10¹²	1	< 0.1%
9.970791953 × 10¹²	1	< 0.1%

Age
Real number (ℝ)

Distinct	62
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48.245667

Minimum	18
Maximum	79
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.6 KiB

Quantile statistics

Minimum	18
5-th percentile	21
Q1	33
median	48
Q3	64
95-th percentile	77
Maximum	79
Range	61
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	17.867038
Coefficient of variation (CV)	0.37033457
Kurtosis	-1.1937588
Mean	48.245667
Median Absolute Deviation (MAD)	15
Skewness	0.030996074
Sum	144737
Variance	319.23106
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38	70	2.3%
77	65	2.2%
57	62	2.1%
69	59	2.0%
42	58	1.9%
34	57	1.9%
33	57	1.9%
50	56	1.9%
52	56	1.9%
27	56	1.9%
Other values (52)	2404	80.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18	42	1.4%
19	54	1.8%
20	50	1.7%
21	50	1.7%
22	54	1.8%
23	50	1.7%
24	45	1.5%
25	42	1.4%
26	40	1.3%
27	56	1.9%

Value	Count	Frequency (%)
79	47	1.6%
78	47	1.6%
77	65	2.2%
76	30	1.0%
75	54	1.8%
74	48	1.6%
73	46	1.5%
72	45	1.5%
71	51	1.7%
70	36	1.2%

Gender
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Male	1544
Female	1456

Length

Max length	6
Median length	4
Mean length	4.9706667
Min length	4

Characters and Unicode

Total characters	14912
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Female
2nd row	Female
3rd row	Female
4th row	Male
5th row	Male

Common Values

Value	Count	Frequency (%)
Male	1544	51.5%
Female	1456	48.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
male	1544	51.5%
female	1456	48.5%

Most occurring characters

Value	Count	Frequency (%)
e	4456	29.9%
a	3000	20.1%
l	3000	20.1%
M	1544	10.4%
F	1456	9.8%
m	1456	9.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	11912	79.9%
Uppercase Letter	3000	20.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	4456	37.4%
a	3000	25.2%
l	3000	25.2%
m	1456	12.2%

Uppercase Letter

Value	Count	Frequency (%)
M	1544	51.5%
F	1456	48.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14912	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	4456	29.9%
a	3000	20.1%
l	3000	20.1%
M	1544	10.4%
F	1456	9.8%
m	1456	9.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14912	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	4456	29.9%
a	3000	20.1%
l	3000	20.1%
M	1544	10.4%
F	1456	9.8%
m	1456	9.8%

Race
Categorical

Distinct	5
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Hispanic	612
Other	609
Asian	598
White	598
Black	583

Length

Max length	8
Median length	5
Mean length	5.612
Min length	5

Characters and Unicode

Total characters	16836
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Other
2nd row	Asian
3rd row	White
4th row	White
5th row	White

Common Values

Value	Count	Frequency (%)
Hispanic	612	20.4%
Other	609	20.3%
Asian	598	19.9%
White	598	19.9%
Black	583	19.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
hispanic	612	20.4%
other	609	20.3%
asian	598	19.9%
white	598	19.9%
black	583	19.4%

Most occurring characters

Value	Count	Frequency (%)
i	2420	14.4%
a	1793	10.6%
s	1210	7.2%
n	1210	7.2%
t	1207	7.2%
e	1207	7.2%
h	1207	7.2%
c	1195	7.1%
H	612	3.6%
p	612	3.6%
Other values (7)	4163	24.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	13836	82.2%
Uppercase Letter	3000	17.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	2420	17.5%
a	1793	13.0%
s	1210	8.7%
n	1210	8.7%
t	1207	8.7%
e	1207	8.7%
h	1207	8.7%
c	1195	8.6%
p	612	4.4%
r	609	4.4%
Other values (2)	1166	8.4%

Uppercase Letter

Value	Count	Frequency (%)
H	612	20.4%
O	609	20.3%
A	598	19.9%
W	598	19.9%
B	583	19.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	16836	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	2420	14.4%
a	1793	10.6%
s	1210	7.2%
n	1210	7.2%
t	1207	7.2%
e	1207	7.2%
h	1207	7.2%
c	1195	7.1%
H	612	3.6%
p	612	3.6%
Other values (7)	4163	24.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16836	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	2420	14.4%
a	1793	10.6%
s	1210	7.2%
n	1210	7.2%
t	1207	7.2%
e	1207	7.2%
h	1207	7.2%
c	1195	7.1%
H	612	3.6%
p	612	3.6%
Other values (7)	4163	24.7%

ZipCode
Categorical

Distinct	5
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

30301	666
73301	621
90210	602
60601	559
10001	552

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	15000
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	73301
2nd row	60601
3rd row	90210
4th row	10001
5th row	10001

Common Values

Value	Count	Frequency (%)
30301	666	22.2%
73301	621	20.7%
90210	602	20.1%
60601	559	18.6%
10001	552	18.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
30301	666	22.2%
73301	621	20.7%
90210	602	20.1%
60601	559	18.6%
10001	552	18.4%

Most occurring characters

Value	Count	Frequency (%)
0	5931	39.5%
1	3552	23.7%
3	2574	17.2%
6	1118	7.5%
7	621	4.1%
9	602	4.0%
2	602	4.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	15000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5931	39.5%
1	3552	23.7%
3	2574	17.2%
6	1118	7.5%
7	621	4.1%
9	602	4.0%
2	602	4.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	15000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5931	39.5%
1	3552	23.7%
3	2574	17.2%
6	1118	7.5%
7	621	4.1%
9	602	4.0%
2	602	4.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5931	39.5%
1	3552	23.7%
3	2574	17.2%
6	1118	7.5%
7	621	4.1%
9	602	4.0%
2	602	4.0%

ChronicPainConditions
Categorical

Distinct	5
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Fibromyalgia	633
Cancer Pain	621
Arthritis	585
Post-Surgery Pain	583
Chronic Back Pain	578

Length

Max length	17
Median length	12
Mean length	13.143
Min length	9

Characters and Unicode

Total characters	39429
Distinct characters	25
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Fibromyalgia
2nd row	Cancer Pain
3rd row	Fibromyalgia
4th row	Fibromyalgia
5th row	Post-Surgery Pain

Common Values

Value	Count	Frequency (%)
Fibromyalgia	633	21.1%
Cancer Pain	621	20.7%
Arthritis	585	19.5%
Post-Surgery Pain	583	19.4%
Chronic Back Pain	578	19.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pain	1782	33.2%
fibromyalgia	633	11.8%
cancer	621	11.6%
arthritis	585	10.9%
post-surgery	583	10.9%
chronic	578	10.8%
back	578	10.8%

Most occurring characters

Value	Count	Frequency (%)
i	4796	12.2%
a	4247	10.8%
r	4168	10.6%
n	2981	7.6%
P	2365	6.0%
	2360	6.0%
o	1794	4.5%
c	1777	4.5%
t	1753	4.4%
y	1216	3.1%
Other values (15)	11972	30.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	30543	77.5%
Uppercase Letter	5943	15.1%
Space Separator	2360	6.0%
Dash Punctuation	583	1.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	4796	15.7%
a	4247	13.9%
r	4168	13.6%
n	2981	9.8%
o	1794	5.9%
c	1777	5.8%
t	1753	5.7%
y	1216	4.0%
g	1216	4.0%
e	1204	3.9%
Other values (7)	5391	17.7%

Uppercase Letter

Value	Count	Frequency (%)
P	2365	39.8%
C	1199	20.2%
F	633	10.7%
A	585	9.8%
S	583	9.8%
B	578	9.7%

Space Separator

Value	Count	Frequency (%)
	2360	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	583	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	36486	92.5%
Common	2943	7.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	4796	13.1%
a	4247	11.6%
r	4168	11.4%
n	2981	8.2%
P	2365	6.5%
o	1794	4.9%
c	1777	4.9%
t	1753	4.8%
y	1216	3.3%
g	1216	3.3%
Other values (13)	10173	27.9%

Common

Value	Count	Frequency (%)
	2360	80.2%
-	583	19.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	39429	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	4796	12.2%
a	4247	10.8%
r	4168	10.6%
n	2981	7.6%
P	2365	6.0%
	2360	6.0%
o	1794	4.5%
c	1777	4.5%
t	1753	4.4%
y	1216	3.1%
Other values (15)	11972	30.4%

NumOpioidPrescriptions
Real number (ℝ)

Distinct	19
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.025667

Minimum	1
Maximum	19
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	5
median	10
Q3	15
95-th percentile	18
Maximum	19
Range	18
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	5.3812013
Coefficient of variation (CV)	0.53674249
Kurtosis	-1.1766549
Mean	10.025667
Median Absolute Deviation (MAD)	5
Skewness	0.011644412
Sum	30077
Variance	28.957327
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
10	194	6.5%
5	172	5.7%
6	171	5.7%
13	171	5.7%
18	169	5.6%
12	168	5.6%
16	168	5.6%
7	165	5.5%
3	158	5.3%
4	155	5.2%
Other values (9)	1309	43.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	138	4.6%
2	142	4.7%
3	158	5.3%
4	155	5.2%
5	172	5.7%
6	171	5.7%
7	165	5.5%
8	151	5.0%
9	149	5.0%
10	194	6.5%

Value	Count	Frequency (%)
19	145	4.8%
18	169	5.6%
17	142	4.7%
16	168	5.6%
15	152	5.1%
14	141	4.7%
13	171	5.7%
12	168	5.6%
11	149	5.0%
10	194	6.5%

AverageDosage
Real number (ℝ)

Distinct	95
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.089

Minimum	5
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.6 KiB

Quantile statistics

Minimum	5
5-th percentile	10
Q1	29
median	52
Q3	76
95-th percentile	95
Maximum	99
Range	94
Interquartile range (IQR)	47

Descriptive statistics

Standard deviation	27.392186
Coefficient of variation (CV)	0.52587276
Kurtosis	-1.2205004
Mean	52.089
Median Absolute Deviation (MAD)	24
Skewness	0.034422999
Sum	156267
Variance	750.33186
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33	44	1.5%
73	44	1.5%
21	42	1.4%
83	42	1.4%
34	41	1.4%
56	41	1.4%
31	41	1.4%
30	40	1.3%
86	40	1.3%
29	40	1.3%
Other values (85)	2585	86.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5	21	0.7%
6	33	1.1%
7	29	1.0%
8	24	0.8%
9	36	1.2%
10	23	0.8%
11	31	1.0%
12	32	1.1%
13	28	0.9%
14	29	1.0%

Value	Count	Frequency (%)
99	28	0.9%
98	34	1.1%
97	36	1.2%
96	35	1.2%
95	34	1.1%
94	32	1.1%
93	30	1.0%
92	36	1.2%
91	34	1.1%
90	25	0.8%

DurationOfPrescriptions
Real number (ℝ)

Distinct	29
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.974

Minimum	1
Maximum	29
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	15
Q3	22
95-th percentile	28
Maximum	29
Range	28
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	8.3232055
Coefficient of variation (CV)	0.55584383
Kurtosis	-1.168202
Mean	14.974
Median Absolute Deviation (MAD)	7
Skewness	0.009554749
Sum	44922
Variance	69.275749
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
26	119	4.0%
10	118	3.9%
9	117	3.9%
11	116	3.9%
29	115	3.8%
16	114	3.8%
6	113	3.8%
1	112	3.7%
14	110	3.7%
20	109	3.6%
Other values (19)	1857	61.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	112	3.7%
2	109	3.6%
3	96	3.2%
4	83	2.8%
5	94	3.1%
6	113	3.8%
7	96	3.2%
8	94	3.1%
9	117	3.9%
10	118	3.9%

Value	Count	Frequency (%)
29	115	3.8%
28	92	3.1%
27	90	3.0%
26	119	4.0%
25	105	3.5%
24	84	2.8%
23	107	3.6%
22	103	3.4%
21	95	3.2%
20	109	3.6%

NumHealthcareVisits
Real number (ℝ)

ZEROS

Distinct	20
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.5823333

Minimum	0
Maximum	19
Zeros	164
Zeros (%)	5.5%
Negative	0
Negative (%)	0.0%
Memory size	23.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5
median	10
Q3	15
95-th percentile	19
Maximum	19
Range	19
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	5.7690249
Coefficient of variation (CV)	0.60204803
Kurtosis	-1.1987407
Mean	9.5823333
Median Absolute Deviation (MAD)	5
Skewness	-0.029814822
Sum	28747
Variance	33.281648
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
15	180	6.0%
0	164	5.5%
8	162	5.4%
10	158	5.3%
3	158	5.3%
6	157	5.2%
19	154	5.1%
12	154	5.1%
5	149	5.0%
18	148	4.9%
Other values (10)	1416	47.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	164	5.5%
1	134	4.5%
2	140	4.7%
3	158	5.3%
4	132	4.4%
5	149	5.0%
6	157	5.2%
7	137	4.6%
8	162	5.4%
9	141	4.7%

Value	Count	Frequency (%)
19	154	5.1%
18	148	4.9%
17	147	4.9%
16	147	4.9%
15	180	6.0%
14	147	4.9%
13	146	4.9%
12	154	5.1%
11	145	4.8%
10	158	5.3%

NumHospitalizations
Categorical

Distinct	5
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

1	613
3	607
2	603
4	589
0	588

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	3000
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	2
4th row	2
5th row	3

Common Values

Value	Count	Frequency (%)
1	613	20.4%
3	607	20.2%
2	603	20.1%
4	589	19.6%
0	588	19.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	613	20.4%
3	607	20.2%
2	603	20.1%
4	589	19.6%
0	588	19.6%

Most occurring characters

Value	Count	Frequency (%)
1	613	20.4%
3	607	20.2%
2	603	20.1%
4	589	19.6%
0	588	19.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	613	20.4%
3	607	20.2%
2	603	20.1%
4	589	19.6%
0	588	19.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	3000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	613	20.4%
3	607	20.2%
2	603	20.1%
4	589	19.6%
0	588	19.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	613	20.4%
3	607	20.2%
2	603	20.1%
4	589	19.6%
0	588	19.6%

PainManagementTreatment
Boolean

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 KiB

False	2411
True	589

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	2411	80.4%
True	589	19.6%

PrescriptionDate
Date

Distinct	1355
Distinct (%)	45.2%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Minimum	2020-01-01 00:00:00
Maximum	2024-05-23 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

MedicationName
Categorical

Distinct	12
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Morphine	283
Tramadol	272
Oxycodone	263
Tapentadol	263
Meperidine	260
Other values (7)	1659

Length

Max length	13
Median length	10
Mean length	9.69
Min length	7

Characters and Unicode

Total characters	29070
Distinct characters	23
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Hydrocodone
2nd row	Hydromorphone
3rd row	Hydrocodone
4th row	Oxymorphone
5th row	Tramadol

Common Values

Value	Count	Frequency (%)
Morphine	283	9.4%
Tramadol	272	9.1%
Oxycodone	263	8.8%
Tapentadol	263	8.8%
Meperidine	260	8.7%
Methadone	258	8.6%
Codeine	246	8.2%
Buprenorphine	245	8.2%
Hydrocodone	244	8.1%
Hydromorphone	224	7.5%
Other values (2)	442	14.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
morphine	283	9.4%
tramadol	272	9.1%
oxycodone	263	8.8%
tapentadol	263	8.8%
meperidine	260	8.7%
methadone	258	8.6%
codeine	246	8.2%
buprenorphine	245	8.2%
hydrocodone	244	8.1%
hydromorphone	224	7.5%
Other values (2)	442	14.7%

Most occurring characters

Value	Count	Frequency (%)
e	3997	13.7%
o	3945	13.6%
n	3191	11.0%
d	2274	7.8%
r	2221	7.6%
p	1744	6.0%
a	1546	5.3%
i	1294	4.5%
h	1234	4.2%
y	1173	4.0%
Other values (13)	6451	22.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	26070	89.7%
Uppercase Letter	3000	10.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	3997	15.3%
o	3945	15.1%
n	3191	12.2%
d	2274	8.7%
r	2221	8.5%
p	1744	6.7%
a	1546	5.9%
i	1294	5.0%
h	1234	4.7%
y	1173	4.5%
Other values (6)	3451	13.2%

Uppercase Letter

Value	Count	Frequency (%)
M	801	26.7%
T	535	17.8%
O	487	16.2%
H	468	15.6%
C	246	8.2%
B	245	8.2%
F	218	7.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	29070	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	3997	13.7%
o	3945	13.6%
n	3191	11.0%
d	2274	7.8%
r	2221	7.6%
p	1744	6.0%
a	1546	5.3%
i	1294	4.5%
h	1234	4.2%
y	1173	4.0%
Other values (13)	6451	22.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	29070	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	3997	13.7%
o	3945	13.6%
n	3191	11.0%
d	2274	7.8%
r	2221	7.6%
p	1744	6.0%
a	1546	5.3%
i	1294	4.5%
h	1234	4.2%
y	1173	4.0%
Other values (13)	6451	22.2%

Dosage
Categorical

Distinct	12
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

10 mg	459
80 mg	250
40 mg	244
75 mcg/hour	243
20 mg	237
Other values (7)	1567

Length

Max length	13
Median length	5
Mean length	7.0466667
Min length	4

Characters and Unicode

Total characters	21140
Distinct characters	19
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	10 mg
2nd row	100 mcg/hour
3rd row	20 mg
4th row	10 mg
5th row	80 mg

Common Values

Value	Count	Frequency (%)
10 mg	459	15.3%
80 mg	250	8.3%
40 mg	244	8.1%
75 mcg/hour	243	8.1%
20 mg	237	7.9%
60 mg	236	7.9%
50 mcg/hour	233	7.8%
2.5 mg	231	7.7%
100 mcg/hour	218	7.3%
12.5 mcg/hour	218	7.3%
Other values (2)	431	14.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mg	2088	34.8%
mcg/hour	912	15.2%
10	459	7.6%
80	250	4.2%
40	244	4.1%
75	243	4.0%
20	237	4.0%
60	236	3.9%
50	233	3.9%
2.5	231	3.9%
Other values (4)	867	14.4%

Most occurring characters

Value	Count	Frequency (%)
	3000	14.2%
m	3000	14.2%
g	3000	14.2%
0	2309	10.9%
5	1142	5.4%
c	912	4.3%
h	912	4.3%
r	912	4.3%
u	912	4.3%
o	912	4.3%
Other values (9)	4129	19.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	10560	50.0%
Decimal Number	6219	29.4%
Space Separator	3000	14.2%
Other Punctuation	1361	6.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2309	37.1%
5	1142	18.4%
1	895	14.4%
2	686	11.0%
8	250	4.0%
4	244	3.9%
7	243	3.9%
6	236	3.8%
3	214	3.4%

Lowercase Letter

Value	Count	Frequency (%)
m	3000	28.4%
g	3000	28.4%
c	912	8.6%
h	912	8.6%
r	912	8.6%
u	912	8.6%
o	912	8.6%

Other Punctuation

Value	Count	Frequency (%)
/	912	67.0%
.	449	33.0%

Space Separator

Value	Count	Frequency (%)
	3000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	10580	50.0%
Latin	10560	50.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
	3000	28.4%
0	2309	21.8%
5	1142	10.8%
/	912	8.6%
1	895	8.5%
2	686	6.5%
.	449	4.2%
8	250	2.4%
4	244	2.3%
7	243	2.3%
Other values (2)	450	4.3%

Latin

Value	Count	Frequency (%)
m	3000	28.4%
g	3000	28.4%
c	912	8.6%
h	912	8.6%
r	912	8.6%
u	912	8.6%
o	912	8.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21140	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3000	14.2%
m	3000	14.2%
g	3000	14.2%
0	2309	10.9%
5	1142	5.4%
c	912	4.3%
h	912	4.3%
r	912	4.3%
u	912	4.3%
o	912	4.3%
Other values (9)	4129	19.5%

Frequency
Categorical

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

every 8 hours	763
once daily	761
every 12 hours	753
every 4-6 hours	723

Length

Max length	15
Median length	14
Mean length	12.972
Min length	10

Characters and Unicode

Total characters	38916
Distinct characters	21
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	every 8 hours
2nd row	every 8 hours
3rd row	every 4-6 hours
4th row	every 12 hours
5th row	every 4-6 hours

Common Values

Value	Count	Frequency (%)
every 8 hours	763	25.4%
once daily	761	25.4%
every 12 hours	753	25.1%
every 4-6 hours	723	24.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
every	2239	27.2%
hours	2239	27.2%
8	763	9.3%
once	761	9.2%
daily	761	9.2%
12	753	9.1%
4-6	723	8.8%

Most occurring characters

Value	Count	Frequency (%)
e	5239	13.5%
	5239	13.5%
r	4478	11.5%
y	3000	7.7%
o	3000	7.7%
h	2239	5.8%
u	2239	5.8%
s	2239	5.8%
v	2239	5.8%
8	763	2.0%
Other values (11)	8241	21.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	29239	75.1%
Space Separator	5239	13.5%
Decimal Number	3715	9.5%
Dash Punctuation	723	1.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	5239	17.9%
r	4478	15.3%
y	3000	10.3%
o	3000	10.3%
h	2239	7.7%
u	2239	7.7%
s	2239	7.7%
v	2239	7.7%
a	761	2.6%
l	761	2.6%
Other values (4)	3044	10.4%

Decimal Number

Value	Count	Frequency (%)
8	763	20.5%
1	753	20.3%
2	753	20.3%
4	723	19.5%
6	723	19.5%

Space Separator

Value	Count	Frequency (%)
	5239	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	723	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	29239	75.1%
Common	9677	24.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	5239	17.9%
r	4478	15.3%
y	3000	10.3%
o	3000	10.3%
h	2239	7.7%
u	2239	7.7%
s	2239	7.7%
v	2239	7.7%
a	761	2.6%
l	761	2.6%
Other values (4)	3044	10.4%

Common

Value	Count	Frequency (%)
	5239	54.1%
8	763	7.9%
1	753	7.8%
2	753	7.8%
4	723	7.5%
-	723	7.5%
6	723	7.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	38916	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	5239	13.5%
	5239	13.5%
r	4478	11.5%
y	3000	7.7%
o	3000	7.7%
h	2239	5.8%
u	2239	5.8%
s	2239	5.8%
v	2239	5.8%
8	763	2.0%
Other values (11)	8241	21.2%

Duration
Real number (ℝ)

Distinct	29
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.041

Minimum	1
Maximum	29
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	15
Q3	22
95-th percentile	28
Maximum	29
Range	28
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	8.3515209
Coefficient of variation (CV)	0.55525038
Kurtosis	-1.2053241
Mean	15.041
Median Absolute Deviation (MAD)	7
Skewness	-0.0032739989
Sum	45123
Variance	69.747902
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
23	128	4.3%
17	119	4.0%
21	116	3.9%
4	115	3.8%
12	114	3.8%
24	113	3.8%
2	113	3.8%
10	112	3.7%
7	110	3.7%
29	110	3.7%
Other values (19)	1850	61.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	90	3.0%
2	113	3.8%
3	97	3.2%
4	115	3.8%
5	99	3.3%
6	98	3.3%
7	110	3.7%
8	105	3.5%
9	93	3.1%
10	112	3.7%

Value	Count	Frequency (%)
29	110	3.7%
28	101	3.4%
27	93	3.1%
26	107	3.6%
25	90	3.0%
24	113	3.8%
23	128	4.3%
22	90	3.0%
21	116	3.9%
20	105	3.5%

Refills
Categorical

Distinct	5
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

0	637
4	617
2	591
3	580
1	575

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	3000
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	2
4th row	0
5th row	2

Common Values

Value	Count	Frequency (%)
0	637	21.2%
4	617	20.6%
2	591	19.7%
3	580	19.3%
1	575	19.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	637	21.2%
4	617	20.6%
2	591	19.7%
3	580	19.3%
1	575	19.2%

Most occurring characters

Value	Count	Frequency (%)
0	637	21.2%
4	617	20.6%
2	591	19.7%
3	580	19.3%
1	575	19.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	637	21.2%
4	617	20.6%
2	591	19.7%
3	580	19.3%
1	575	19.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	3000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	637	21.2%
4	617	20.6%
2	591	19.7%
3	580	19.3%
1	575	19.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	637	21.2%
4	617	20.6%
2	591	19.7%
3	580	19.3%
1	575	19.2%

MedicationClass
Categorical

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Analgesic	1029
Narcotic	1014
Opioid	957

Length

Max length	9
Median length	8
Mean length	7.705
Min length	6

Characters and Unicode

Total characters	23115
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Opioid
2nd row	Narcotic
3rd row	Analgesic
4th row	Analgesic
5th row	Analgesic

Common Values

Value	Count	Frequency (%)
Analgesic	1029	34.3%
Narcotic	1014	33.8%
Opioid	957	31.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
analgesic	1029	34.3%
narcotic	1014	33.8%
opioid	957	31.9%

Most occurring characters

Value	Count	Frequency (%)
i	3957	17.1%
c	3057	13.2%
a	2043	8.8%
o	1971	8.5%
A	1029	4.5%
n	1029	4.5%
l	1029	4.5%
g	1029	4.5%
e	1029	4.5%
s	1029	4.5%
Other values (6)	5913	25.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	20115	87.0%
Uppercase Letter	3000	13.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	3957	19.7%
c	3057	15.2%
a	2043	10.2%
o	1971	9.8%
n	1029	5.1%
l	1029	5.1%
g	1029	5.1%
e	1029	5.1%
s	1029	5.1%
r	1014	5.0%
Other values (3)	2928	14.6%

Uppercase Letter

Value	Count	Frequency (%)
A	1029	34.3%
N	1014	33.8%
O	957	31.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	23115	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	3957	17.1%
c	3057	13.2%
a	2043	8.8%
o	1971	8.5%
A	1029	4.5%
n	1029	4.5%
l	1029	4.5%
g	1029	4.5%
e	1029	4.5%
s	1029	4.5%
Other values (6)	5913	25.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	23115	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	3957	17.1%
c	3057	13.2%
a	2043	8.8%
o	1971	8.5%
A	1029	4.5%
n	1029	4.5%
l	1029	4.5%
g	1029	4.5%
e	1029	4.5%
s	1029	4.5%
Other values (6)	5913	25.6%

Adherence
Categorical

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

High	1017
Low	992
Moderate	991

Length

Max length	8
Median length	4
Mean length	4.9906667
Min length	3

Characters and Unicode

Total characters	14972
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Moderate
2nd row	Low
3rd row	Moderate
4th row	Low
5th row	High

Common Values

Value	Count	Frequency (%)
High	1017	33.9%
Low	992	33.1%
Moderate	991	33.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
high	1017	33.9%
low	992	33.1%
moderate	991	33.0%

Most occurring characters

Value	Count	Frequency (%)
o	1983	13.2%
e	1982	13.2%
H	1017	6.8%
i	1017	6.8%
g	1017	6.8%
h	1017	6.8%
L	992	6.6%
w	992	6.6%
M	991	6.6%
d	991	6.6%
Other values (3)	2973	19.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	11972	80.0%
Uppercase Letter	3000	20.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	1983	16.6%
e	1982	16.6%
i	1017	8.5%
g	1017	8.5%
h	1017	8.5%
w	992	8.3%
d	991	8.3%
r	991	8.3%
a	991	8.3%
t	991	8.3%

Uppercase Letter

Value	Count	Frequency (%)
H	1017	33.9%
L	992	33.1%
M	991	33.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14972	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	1983	13.2%
e	1982	13.2%
H	1017	6.8%
i	1017	6.8%
g	1017	6.8%
h	1017	6.8%
L	992	6.6%
w	992	6.6%
M	991	6.6%
d	991	6.6%
Other values (3)	2973	19.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14972	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	1983	13.2%
e	1982	13.2%
H	1017	6.8%
i	1017	6.8%
g	1017	6.8%
h	1017	6.8%
L	992	6.6%
w	992	6.6%
M	991	6.6%
d	991	6.6%
Other values (3)	2973	19.9%

ClinicalNotes
Categorical

Distinct	11
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Recovering from injury, prescribed Codeine.	300
Post-operative pain managed with Hydrocodone.	290
Patient with previous substance abuse, now on Methadone treatment.	280
Patient reports effective pain relief with Tapentadol.	276
Patient reports chronic back pain, prescribed Fentanyl patch.	274
Other values (6)	1580

Length

Max length	66
Median length	54
Mean length	51.982333
Min length	39

Characters and Unicode

Total characters	155947
Distinct characters	38
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Post-operative pain managed with Hydrocodone.
2nd row	Prescribed Oxymorphone for severe pain.
3rd row	Patient reports effective pain relief with Tapentadol.
4th row	Using Tramadol for moderate pain management.
5th row	Patient reports effective pain relief with Tapentadol.

Common Values

Value	Count	Frequency (%)
Recovering from injury, prescribed Codeine.	300	10.0%
Post-operative pain managed with Hydrocodone.	290	9.7%
Patient with previous substance abuse, now on Methadone treatment.	280	9.3%
Patient reports effective pain relief with Tapentadol.	276	9.2%
Patient reports chronic back pain, prescribed Fentanyl patch.	274	9.1%
History of depression, taking Oxycodone for post-surgery pain.	271	9.0%
Prescribed Oxymorphone for severe pain.	269	9.0%
Using Tramadol for moderate pain management.	269	9.0%
Meperidine prescribed for acute pain episodes.	264	8.8%
Chronic arthritis, using Hydromorphone for pain relief.	260	8.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pain	2420	12.2%
prescribed	1354	6.8%
for	1333	6.7%
with	846	4.3%
patient	830	4.2%
reports	550	2.8%
from	547	2.8%
relief	536	2.7%
chronic	534	2.7%
using	529	2.7%
Other values (37)	10375	52.3%

Most occurring characters

Value	Count	Frequency (%)
e	17667	11.3%
	16854	10.8%
r	12950	8.3%
i	11661	7.5%
n	11149	7.1%
o	10403	6.7%
a	9001	5.8%
t	8271	5.3%
p	7268	4.7%
s	6502	4.2%
Other values (28)	44221	28.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	128164	82.2%
Space Separator	16854	10.8%
Uppercase Letter	5736	3.7%
Other Punctuation	4632	3.0%
Dash Punctuation	561	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	17667	13.8%
r	12950	10.1%
i	11661	9.1%
n	11149	8.7%
o	10403	8.1%
a	9001	7.0%
t	8271	6.5%
p	7268	5.7%
s	6502	5.1%
c	5132	4.0%
Other values (14)	28160	22.0%

Uppercase Letter

Value	Count	Frequency (%)
P	1389	24.2%
H	821	14.3%
M	791	13.8%
C	560	9.8%
T	545	9.5%
O	540	9.4%
R	300	5.2%
F	274	4.8%
U	269	4.7%
E	247	4.3%

Other Punctuation

Value	Count	Frequency (%)
.	3000	64.8%
,	1632	35.2%

Space Separator

Value	Count	Frequency (%)
	16854	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	561	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	133900	85.9%
Common	22047	14.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	17667	13.2%
r	12950	9.7%
i	11661	8.7%
n	11149	8.3%
o	10403	7.8%
a	9001	6.7%
t	8271	6.2%
p	7268	5.4%
s	6502	4.9%
c	5132	3.8%
Other values (24)	33896	25.3%

Common

Value	Count	Frequency (%)
	16854	76.4%
.	3000	13.6%
,	1632	7.4%
-	561	2.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	155947	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	17667	11.3%
	16854	10.8%
r	12950	8.3%
i	11661	7.5%
n	11149	7.1%
o	10403	6.7%
a	9001	5.8%
t	8271	5.3%
p	7268	4.7%
s	6502	4.2%
Other values (28)	44221	28.4%

Specialty
Categorical

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Pain Management	765
Primary Care	750
Orthopedics	746
Oncology	739

Length

Max length	15
Median length	12
Mean length	11.531
Min length	8

Characters and Unicode

Total characters	34593
Distinct characters	21
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Orthopedics
2nd row	Pain Management
3rd row	Oncology
4th row	Orthopedics
5th row	Oncology

Common Values

Value	Count	Frequency (%)
Pain Management	765	25.5%
Primary Care	750	25.0%
Orthopedics	746	24.9%
Oncology	739	24.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pain	765	16.9%
management	765	16.9%
primary	750	16.6%
care	750	16.6%
orthopedics	746	16.5%
oncology	739	16.4%

Most occurring characters

Value	Count	Frequency (%)
a	3795	11.0%
n	3034	8.8%
e	3026	8.7%
r	2996	8.7%
i	2261	6.5%
o	2224	6.4%
m	1515	4.4%
P	1515	4.4%
	1515	4.4%
t	1511	4.4%
Other values (11)	11201	32.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	28563	82.6%
Uppercase Letter	4515	13.1%
Space Separator	1515	4.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	3795	13.3%
n	3034	10.6%
e	3026	10.6%
r	2996	10.5%
i	2261	7.9%
o	2224	7.8%
m	1515	5.3%
t	1511	5.3%
g	1504	5.3%
y	1489	5.2%
Other values (6)	5208	18.2%

Uppercase Letter

Value	Count	Frequency (%)
P	1515	33.6%
O	1485	32.9%
M	765	16.9%
C	750	16.6%

Space Separator

Value	Count	Frequency (%)
	1515	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	33078	95.6%
Common	1515	4.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	3795	11.5%
n	3034	9.2%
e	3026	9.1%
r	2996	9.1%
i	2261	6.8%
o	2224	6.7%
m	1515	4.6%
P	1515	4.6%
t	1511	4.6%
g	1504	4.5%
Other values (10)	9697	29.3%

Common

Value	Count	Frequency (%)
	1515	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	34593	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	3795	11.0%
n	3034	8.8%
e	3026	8.7%
r	2996	8.7%
i	2261	6.5%
o	2224	6.4%
m	1515	4.4%
P	1515	4.4%
	1515	4.4%
t	1511	4.4%
Other values (11)	11201	32.4%

AppointmentType
Categorical

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Consultation	1061
Follow-up	1007
Routine Check-up	932

Length

Max length	16
Median length	12
Mean length	12.235667
Min length	9

Characters and Unicode

Total characters	36707
Distinct characters	19
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Routine Check-up
2nd row	Consultation
3rd row	Routine Check-up
4th row	Consultation
5th row	Follow-up

Common Values

Value	Count	Frequency (%)
Consultation	1061	35.4%
Follow-up	1007	33.6%
Routine Check-up	932	31.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
consultation	1061	27.0%
follow-up	1007	25.6%
routine	932	23.7%
check-up	932	23.7%

Most occurring characters

Value	Count	Frequency (%)
o	5068	13.8%
u	3932	10.7%
l	3075	8.4%
n	3054	8.3%
t	3054	8.3%
C	1993	5.4%
i	1993	5.4%
p	1939	5.3%
-	1939	5.3%
e	1864	5.1%
Other values (9)	8796	24.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	29904	81.5%
Uppercase Letter	3932	10.7%
Dash Punctuation	1939	5.3%
Space Separator	932	2.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	5068	16.9%
u	3932	13.1%
l	3075	10.3%
n	3054	10.2%
t	3054	10.2%
i	1993	6.7%
p	1939	6.5%
e	1864	6.2%
s	1061	3.5%
a	1061	3.5%
Other values (4)	3803	12.7%

Uppercase Letter

Value	Count	Frequency (%)
C	1993	50.7%
F	1007	25.6%
R	932	23.7%

Dash Punctuation

Value	Count	Frequency (%)
-	1939	100.0%

Space Separator

Value	Count	Frequency (%)
	932	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	33836	92.2%
Common	2871	7.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	5068	15.0%
u	3932	11.6%
l	3075	9.1%
n	3054	9.0%
t	3054	9.0%
C	1993	5.9%
i	1993	5.9%
p	1939	5.7%
e	1864	5.5%
s	1061	3.1%
Other values (7)	6803	20.1%

Common

Value	Count	Frequency (%)
-	1939	67.5%
	932	32.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	36707	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	5068	13.8%
u	3932	10.7%
l	3075	8.4%
n	3054	8.3%
t	3054	8.3%
C	1993	5.4%
i	1993	5.4%
p	1939	5.3%
-	1939	5.3%
e	1864	5.1%
Other values (9)	8796	24.0%

SubSpecialty
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Specialized	1532
General	1468

Length

Max length	11
Median length	11
Mean length	9.0426667
Min length	7

Characters and Unicode

Total characters	27128
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Specialized
2nd row	General
3rd row	Specialized
4th row	Specialized
5th row	General

Common Values

Value	Count	Frequency (%)
Specialized	1532	51.1%
General	1468	48.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
specialized	1532	51.1%
general	1468	48.9%

Most occurring characters

Value	Count	Frequency (%)
e	6000	22.1%
i	3064	11.3%
a	3000	11.1%
l	3000	11.1%
S	1532	5.6%
p	1532	5.6%
c	1532	5.6%
z	1532	5.6%
d	1532	5.6%
G	1468	5.4%
Other values (2)	2936	10.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	24128	88.9%
Uppercase Letter	3000	11.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	6000	24.9%
i	3064	12.7%
a	3000	12.4%
l	3000	12.4%
p	1532	6.3%
c	1532	6.3%
z	1532	6.3%
d	1532	6.3%
n	1468	6.1%
r	1468	6.1%

Uppercase Letter

Value	Count	Frequency (%)
S	1532	51.1%
G	1468	48.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	27128	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	6000	22.1%
i	3064	11.3%
a	3000	11.1%
l	3000	11.1%
S	1532	5.6%
p	1532	5.6%
c	1532	5.6%
z	1532	5.6%
d	1532	5.6%
G	1468	5.4%
Other values (2)	2936	10.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	27128	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	6000	22.1%
i	3064	11.3%
a	3000	11.1%
l	3000	11.1%
S	1532	5.6%
p	1532	5.6%
c	1532	5.6%
z	1532	5.6%
d	1532	5.6%
G	1468	5.4%
Other values (2)	2936	10.8%

TimeofAppointment
Date

Distinct	2945
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Minimum	2024-07-16 00:00:08
Maximum	2024-07-16 23:59:57

Histogram

Histogram with fixed size bins (bins=50)

TimeSeenbyPhysician
Date

Distinct	2935
Distinct (%)	97.8%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Minimum	2024-07-16 00:00:54
Maximum	2024-07-16 23:59:43

Histogram

Histogram with fixed size bins (bins=50)

TotalTimeSpentwithPhysician
Real number (ℝ)

Distinct	50
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35.008

Minimum	10
Maximum	59
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.6 KiB

Quantile statistics

Minimum	10
5-th percentile	12
Q1	23
median	35
Q3	47
95-th percentile	57
Maximum	59
Range	49
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	14.271621
Coefficient of variation (CV)	0.40766742
Kurtosis	-1.17811
Mean	35.008
Median Absolute Deviation (MAD)	12
Skewness	-0.036898559
Sum	105024
Variance	203.67916
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
43	78	2.6%
47	74	2.5%
26	73	2.4%
34	72	2.4%
54	71	2.4%
52	70	2.3%
59	70	2.3%
19	68	2.3%
50	67	2.2%
20	67	2.2%
Other values (40)	2290	76.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	55	1.8%
11	51	1.7%
12	54	1.8%
13	48	1.6%
14	54	1.8%
15	64	2.1%
16	63	2.1%
17	50	1.7%
18	48	1.6%
19	68	2.3%

Value	Count	Frequency (%)
59	70	2.3%
58	60	2.0%
57	58	1.9%
56	52	1.7%
55	56	1.9%
54	71	2.4%
53	57	1.9%
52	70	2.3%
51	58	1.9%
50	67	2.2%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	PatientID	Age	Gender	Race	ZipCode	ChronicPainConditions	NumOpioidPrescriptions	AverageDosage	DurationOfPrescriptions	NumHealthcareVisits	NumHospitalizations	PainManagementTreatment	PrescriptionDate	MedicationName	Dosage	Frequency	Duration	Refills	MedicationClass	Adherence	ClinicalNotes	Specialty	AppointmentType	SubSpecialty	TimeofAppointment	TimeSeenbyPhysician	TotalTimeSpentwithPhysician
0	4479647884230	54	Female	Other	73301	Fibromyalgia	6	80	7	18	0	No	2023-12-06	Hydrocodone	10 mg	every 8 hours	1	0	Opioid	Moderate	Post-operative pain managed with Hydrocodone.	Orthopedics	Routine Check-up	Specialized	13:39:02	16:33:59	36
1	6354629782347	21	Female	Asian	60601	Cancer Pain	11	70	25	12	0	Yes	2022-02-21	Hydromorphone	100 mcg/hour	every 8 hours	20	0	Narcotic	Low	Prescribed Oxymorphone for severe pain.	Pain Management	Consultation	General	19:44:46	17:33:37	51
2	4665077438222	67	Female	White	90210	Fibromyalgia	5	15	7	10	2	No	2023-05-01	Hydrocodone	20 mg	every 4-6 hours	7	2	Analgesic	Moderate	Patient reports effective pain relief with Tapentadol.	Oncology	Routine Check-up	Specialized	18:05:34	04:39:28	46
3	2844761285195	41	Male	White	10001	Fibromyalgia	16	94	19	14	2	No	2020-03-04	Oxymorphone	10 mg	every 12 hours	28	0	Analgesic	Low	Using Tramadol for moderate pain management.	Orthopedics	Consultation	Specialized	15:16:11	15:52:51	16
4	4785391177871	36	Male	White	10001	Post-Surgery Pain	7	22	6	9	3	Yes	2020-09-19	Tramadol	80 mg	every 4-6 hours	25	2	Analgesic	High	Patient reports effective pain relief with Tapentadol.	Oncology	Follow-up	General	22:17:05	02:17:33	14
5	3625457519614	53	Female	Black	10001	Chronic Back Pain	5	89	11	8	4	No	2021-06-28	Hydromorphone	60 mg	once daily	9	4	Analgesic	Low	Patient with previous substance abuse, now on Methadone treatment.	Oncology	Consultation	Specialized	01:36:35	19:34:36	24
6	9323406799110	77	Male	Black	73301	Post-Surgery Pain	11	56	29	8	2	Yes	2020-08-20	Codeine	60 mg	every 8 hours	28	1	Analgesic	Moderate	Using Tramadol for moderate pain management.	Orthopedics	Consultation	General	16:56:53	02:55:40	51
7	6902918791152	56	Female	Hispanic	60601	Post-Surgery Pain	15	50	11	19	3	No	2020-09-05	Morphine	80 mg	every 12 hours	26	1	Narcotic	High	Patient with previous substance abuse, now on Methadone treatment.	Oncology	Consultation	General	09:17:59	23:23:25	17
8	434358051986	27	Female	Hispanic	10001	Fibromyalgia	3	48	7	0	4	No	2020-09-08	Buprenorphine	100 mcg/hour	every 12 hours	17	1	Analgesic	Moderate	Patient reports effective pain relief with Tapentadol.	Orthopedics	Consultation	General	15:39:28	22:41:01	18
9	9499380676119	42	Male	Hispanic	10001	Fibromyalgia	5	26	2	16	0	Yes	2021-12-17	Oxycodone	12.5 mcg/hour	every 8 hours	21	4	Narcotic	Low	Prescribed Oxymorphone for severe pain.	Oncology	Consultation	General	12:51:13	04:39:45	20

	PatientID	Age	Gender	Race	ZipCode	ChronicPainConditions	NumOpioidPrescriptions	AverageDosage	DurationOfPrescriptions	NumHealthcareVisits	NumHospitalizations	PainManagementTreatment	PrescriptionDate	MedicationName	Dosage	Frequency	Duration	Refills	MedicationClass	Adherence	ClinicalNotes	Specialty	AppointmentType	SubSpecialty	TimeofAppointment	TimeSeenbyPhysician	TotalTimeSpentwithPhysician
2990	1612536616106	24	Female	Black	60601	Chronic Back Pain	16	11	27	2	2	Yes	2020-08-15	Hydromorphone	80 mg	once daily	7	0	Narcotic	High	History of depression, taking Oxycodone for post-surgery pain.	Pain Management	Consultation	Specialized	04:08:15	04:02:39	37
2991	3476750223797	77	Male	Hispanic	30301	Chronic Back Pain	19	69	15	6	0	No	2023-11-30	Morphine	100 mcg/hour	every 12 hours	1	4	Opioid	High	Experiencing severe pain from cancer, prescribed Morphine.	Orthopedics	Consultation	Specialized	01:16:34	17:47:09	31
2992	3844620671502	38	Female	Other	30301	Arthritis	10	28	10	2	4	No	2023-01-11	Morphine	80 mg	every 4-6 hours	24	3	Analgesic	High	Meperidine prescribed for acute pain episodes.	Orthopedics	Consultation	General	04:57:36	04:35:29	50
2993	5190759422798	55	Male	White	73301	Post-Surgery Pain	16	49	4	16	4	No	2024-02-03	Morphine	5 mg	every 8 hours	12	2	Opioid	Low	Patient reports effective pain relief with Tapentadol.	Pain Management	Consultation	General	17:27:17	17:45:29	22
2994	3410939394533	60	Male	Hispanic	73301	Post-Surgery Pain	5	65	21	7	3	No	2021-04-11	Methadone	30 mg	every 8 hours	5	0	Narcotic	Low	Prescribed Oxymorphone for severe pain.	Oncology	Consultation	Specialized	07:15:35	13:42:58	50
2995	9657263226381	66	Male	Black	10001	Chronic Back Pain	16	23	28	18	2	No	2021-06-18	Hydromorphone	60 mg	every 4-6 hours	9	3	Opioid	Moderate	Chronic arthritis, using Hydromorphone for pain relief.	Orthopedics	Consultation	Specialized	10:37:42	22:54:39	56
2996	8361706256156	68	Female	Other	90210	Cancer Pain	1	36	1	13	1	No	2020-07-14	Oxycodone	12.5 mcg/hour	every 12 hours	12	2	Opioid	Low	Post-operative pain managed with Hydrocodone.	Pain Management	Follow-up	General	11:33:25	06:17:30	59
2997	2029879662568	45	Male	Hispanic	90210	Post-Surgery Pain	5	34	14	4	1	No	2023-08-02	Codeine	20 mg	every 4-6 hours	11	1	Analgesic	High	Meperidine prescribed for acute pain episodes.	Orthopedics	Consultation	Specialized	18:12:36	03:07:30	45
2998	927963016179	74	Female	Hispanic	30301	Fibromyalgia	13	69	20	18	2	No	2020-12-19	Codeine	2.5 mg	every 4-6 hours	12	4	Analgesic	Low	Prescribed Oxymorphone for severe pain.	Orthopedics	Routine Check-up	General	13:50:41	21:08:51	31
2999	3958201494210	61	Female	White	10001	Fibromyalgia	13	36	20	12	4	No	2022-10-17	Hydromorphone	20 mg	every 4-6 hours	3	1	Opioid	Low	History of depression, taking Oxycodone for post-surgery pain.	Oncology	Follow-up	Specialized	15:32:54	05:52:29	13

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter